Important features that affect the number of visitors

Time and Date are the most important variables.

Effect of hours on visitors count

  • We can see that there are many customers at night from 7pm until 12pm, but the highest number of visitors were at 22pm and 23pm.

The effect of the day on visitors count

  • weekends have the highest number of visitors.

Discovering what are the best seller item using the products data

## [1] "Flat white"
## [1] 64124.9

Flat White is the best seller and most profitable item, the profits are 64124.9!

Items with more than 2000 Pieces sold in 11 months

## [1] "Flat white"                  "Aqua Carpathica Water 330ml"
## [3] "Hot latte"                   "Cappuccino"

The best selling items are drinks. Looks like we drink hot drinks even in the very hot weather,since most of them are hot drinks. (At least water is on the list)

Which Items are not profitable?

## [1] "hot coconut latte"

Maybe it is a good idea to think about replacing or removing this drink.

Conclusion

To increase the number of visitors and thus profits, I suggest focusing on weekends and night hours as they tend to increase the number of people. Also, removing unprofitable products and increasing the number of profitable products may help.